Data Visualization Project Summary

{(whoami|} Name: Mussa Yousef
Module: Data Visualization
Email: mussa.yousef.1@city.ac.uk {|whoami)}

{(task|}

You should complete this datavis project summary document and submit it, along with any necessary supplementary files to Moodle by Sunday 18th April, 5pm UK time (16:00 GMT). Submissions will be awarded up to 80 marks towards your coursework assessment total.

You are also encouraged to regularly commit and push changes to your datavis project throughout the term as you develop your project.

{|task)}

{(questions|}

How has the coronavirus impacted policing in London? More specifically:

  1. Did the lockdown 2020 affect the number of stop and searches in London?

  2. What trends could be found in Policing stop by race and age throughout the year of 2020?

  3. What crimes committed was given most arrests through 2020 and what trends could be seen for this in the demographic of people arrested during 2020?

  4. Which boroughs in London saw the most crimes committed? Was this different from when London was in lockdown compared to out of Lockdown?

{|questions)}

{(visualization|}

1. Did the lockdown 2020 affect the number of stop and searches in London?

JanFebMarAprMayJunJulAugSepOctNovDec010,00020,00030,00040,000numStops2nd Lockdown (Due …Initial UK lockdownevent

2. What trends could be found in Policing stop by race and age throughout the year of 2020?

010,00020,00030,00040,000Count of RecordsAsianBlackOtherWhite10-1718-2425-34over 34under 1010-1718-2425-34over 34under 1010-1718-2425-34over 34under 1010-1718-2425-34over 34under 10

020,00040,00060,00080,000Count of RecordsA no further action disposalArrestCaution (simple or conditional)Community resolutionPenalty Notice for DisorderSummons / charged by postAsianBlackOtherWhiteAsianBlackOtherWhiteAsianBlackOtherWhiteAsianBlackOtherWhiteAsianBlackOtherWhiteAsianBlackOtherWhite

051015Count of RecordsAsianBlackOtherWhite2020AprilJulyOctober2020AprilJulyOctober2020AprilJulyOctober2020AprilJulyOctober

{"$schema":"https://vega.github.io/schema/vega/v5.json","width":600,"height":600,"data":[{"name":"age","values":[{"Ethnicity":"Asian","Age range":"18-24","numPeople":21397},{"Ethnicity":"Asian","Age range":"25-34","numPeople":12041},{"Ethnicity":"Asian","Age range":"over 34","numPeople":5754},{"Ethnicity":"Asian","Age range":"10-17","numPeople":5529},{"Ethnicity":"Asian","Age range":"under 10","numPeople":15},{"Ethnicity":"Black","Age range":"18-24","numPeople":37151},{"Ethnicity":"Black","Age range":"25-34","numPeople":20531},{"Ethnicity":"Black","Age range":"10-17","numPeople":19119},{"Ethnicity":"Black","Age range":"over 34","numPeople":13409},{"Ethnicity":"Black","Age range":"under 10","numPeople":17},{"Ethnicity":"Other","Age range":"18-24","numPeople":5544},{"Ethnicity":"Other","Age range":"25-34","numPeople":2904},{"Ethnicity":"Other","Age range":"10-17","numPeople":1944},{"Ethnicity":"Other","Age range":"over 34","numPeople":1320},{"Ethnicity":"Other","Age range":"under 10","numPeople":8},{"Ethnicity":"White","Age range":"18-24","numPeople":32153},{"Ethnicity":"White","Age range":"25-34","numPeople":26536},{"Ethnicity":"White","Age range":"over 34","numPeople":24680},{"Ethnicity":"White","Age range":"10-17","numPeople":16669},{"Ethnicity":"White","Age range":"under 10","numPeople":16}],"transform":[{"type":"formula","expr":"datum['Ethnicity']","as":"stk1","initonly":false},{"type":"formula","expr":"datum['Age range']","as":"stk2","initonly":false},{"type":"formula","expr":"datum['numPeople']","as":"size","initonly":false}]},{"name":"nodes","source":"age","transform":[{"type":"filter","expr":"!groupSelector || groupSelector.stk1 == datum.stk1 || groupSelector.stk2 == datum.stk2"},{"type":"formula","expr":"datum.stk1+datum.stk2","as":"key","initonly":false},{"type":"fold","fields":["stk1","stk2"],"as":["stack","grpId"]},{"type":"formula","expr":"datum.stack == 'stk1' ? datum.stk1+' '+datum.stk2 : datum.stk2+' '+datum.stk1","as":"sortField","initonly":false},{"type":"stack","field":"size","sort":{"field":["sortField"],"order":["descending"]},"groupby":["stack"]},{"type":"formula","expr":"(datum.y0+datum.y1)/2","as":"yc","initonly":false}]},{"name":"groups","source":"nodes","transform":[{"type":"aggregate","fields":["size"],"ops":["sum"],"groupby":["stack","grpId"],"as":["total"]},{"type":"stack","field":"total","sort":{"field":["grpId"],"order":["descending"]},"groupby":["stack"]},{"type":"formula","expr":"scale('yScale', datum.y0)","as":"scaledY0","initonly":false},{"type":"formula","expr":"scale('yScale', datum.y1)","as":"scaledY1","initonly":false},{"type":"formula","expr":"datum.stack == 'stk1'","as":"rightLabel","initonly":false},{"type":"formula","expr":"datum.total/domain('yScale')[1]","as":"percentage","initonly":false}]},{"name":"destinationNodes","source":"nodes","transform":[{"type":"filter","expr":"datum.stack == 'stk2'"}]},{"name":"edges","source":"nodes","transform":[{"type":"filter","expr":"datum.stack == 'stk1'"},{"type":"lookup","from":"destinationNodes","key":"key","fields":["key"],"as":["target"]},{"type":"linkpath","orient":"horizontal","shape":"diagonal","sourceX":{"expr":"scale('xScale', 'stk1') + bandwidth('xScale')"},"sourceY":{"expr":"scale('yScale', datum.yc)"},"targetX":{"expr":"scale('xScale', 'stk2')"},"targetY":{"expr":"scale('yScale', datum.target.yc)"}},{"type":"formula","expr":"range('yScale')[0]-scale('yScale', datum.size)","as":"strokeWidth","initonly":false},{"type":"formula","expr":"datum.size/domain('yScale')[1]","as":"percentage","initonly":false}]}],"signals":[{"name":"groupHover","value":"{}","on":[{"events":"@groupMark:mouseover","update":"{stk1:datum.stack=='stk1' && datum.grpId, stk2:datum.stack=='stk2' && datum.grpId}"},{"events":"mouseout","update":"{}"}]},{"name":"groupSelector","value":false,"on":[{"events":"@groupMark:click!","update":"{stack:datum.stack, stk1:datum.stack=='stk1' && datum.grpId, stk2:datum.stack=='stk2' && datum.grpId}"},{"events":[{"type":"click","markname":"groupReset"},{"type":"dblclick"}],"update":"false"}]}],"scales":[{"name":"xScale","type":"band","domain":["stk1","stk2"],"range":"width","paddingInner":0.95,"paddingOuter":0.05},{"name":"yScale","type":"linear","domain":{"data":"nodes","field":"y1"},"range":"height"},{"name":"cScale","type":"ordinal","range":"category"},{"name":"stackNames","type":"ordinal","domain":["stk1","stk2"],"range":["Ethnicity","Age range"]}],"axes":[{"scale":"xScale","orient":"top","domain":false,"ticks":false,"labelPadding":10,"encode":{"labels":{"update":{"text":{"scale":"stackNames","field":"value"}}}}},{"scale":"yScale","orient":"left","domain":false,"ticks":false,"labels":false}],"marks":[{"type":"rect","from":{"data":"nodes"},"encode":{"enter":{"width":{"scale":"xScale","band":1},"x":{"scale":"xScale","field":"stack"},"y":{"scale":"yScale","field":"y0"},"y2":{"scale":"yScale","field":"y1"},"fill":{"scale":"cScale","field":"grpId"},"stroke":{"value":"black"},"strokeWidth":{"value":0.2}}}},{"type":"rect","name":"groupMark","from":{"data":"groups"},"encode":{"enter":{"fillOpacity":{"value":0},"fill":{"value":"white"},"width":{"scale":"xScale","band":1},"stroke":{"value":"white"},"strokeWidth":{"value":2},"cornerRadius":{"value":2}},"update":{"x":{"scale":"xScale","field":"stack"},"y":{"field":"scaledY0"},"y2":{"field":"scaledY1"},"tooltip":{"signal":"datum.grpId + ' ' + format(datum.total, ',.0f') + ' (' + format(datum.percentage, '.1%') + ')'"}},"hover":{"strokeOpacity":{"value":1}}}},{"type":"path","name":"edgeMark","from":{"data":"edges"},"clip":true,"encode":{"update":{"stroke":[{"test":"groupSelector && groupSelector.stack=='stk1'","scale":"cScale","field":"stk2"},{"scale":"cScale","field":"grpId"}],"strokeWidth":{"field":"strokeWidth"},"path":{"field":"path"},"strokeOpacity":{"signal":"!groupSelector && (groupHover.stk1 == datum.stk1 || groupHover.stk2 == datum.stk2) ? 0.9 : 0.3"},"zindex":{"signal":"!groupSelector && (groupHover.stk1 == datum.stk1 || groupHover.stk2 == datum.stk2) ? 1 : 0"},"tooltip":{"signal":"datum.stk1 + ' → ' + datum.stk2 + ' ' + format(datum.size, ',.0f') + ' (' + format(datum.percentage, '.1%') + ')'"}},"hover":{"strokeOpacity":{"value":1}}}},{"type":"text","from":{"data":"groups"},"interactive":false,"encode":{"update":{"x":{"signal":"scale('xScale', datum.stack) + (datum.rightLabel ? bandwidth('xScale') + 8 : -8)"},"y":{"signal":"(datum.scaledY0 + datum.scaledY1)/2"},"align":{"signal":"datum.rightLabel ? 'left' : 'right'"},"baseline":{"value":"middle"},"fontWeight":{"value":"bold"},"text":{"signal":"abs(datum.scaledY0-datum.scaledY1) > 13 ? datum.grpId : ''"}}}}]}

3. What crimes committed was given most arrests through 2020 and what trends could be seen for this in the demographic of people arrested during 2020?

{"$schema":"https://vega.github.io/schema/vega/v5.json","width":600,"height":600,"data":[{"name":"outcome","values":[{"Ethnicity":"Asian","Outcome":"A no further action disposal","numPeople":33759},{"Ethnicity":"Asian","Outcome":"Arrest","numPeople":4258},{"Ethnicity":"Asian","Outcome":"Community resolution","numPeople":4099},{"Ethnicity":"Asian","Outcome":"Penalty Notice for Disorder","numPeople":1855},{"Ethnicity":"Asian","Outcome":"Summons / charged by post","numPeople":732},{"Ethnicity":"Asian","Outcome":"Caution (simple or conditional)","numPeople":33},{"Ethnicity":"Black","Outcome":"A no further action disposal","numPeople":67732},{"Ethnicity":"Black","Outcome":"Arrest","numPeople":11960},{"Ethnicity":"Black","Outcome":"Community resolution","numPeople":6717},{"Ethnicity":"Black","Outcome":"Penalty Notice for Disorder","numPeople":2470},{"Ethnicity":"Black","Outcome":"Summons / charged by post","numPeople":1289},{"Ethnicity":"Black","Outcome":"Caution (simple or conditional)","numPeople":59},{"Ethnicity":"Other","Outcome":"A no further action disposal","numPeople":8981},{"Ethnicity":"Other","Outcome":"Arrest","numPeople":1250},{"Ethnicity":"Other","Outcome":"Community resolution","numPeople":1019},{"Ethnicity":"Other","Outcome":"Penalty Notice for Disorder","numPeople":321},{"Ethnicity":"Other","Outcome":"Summons / charged by post","numPeople":144},{"Ethnicity":"Other","Outcome":"Caution (simple or conditional)","numPeople":5},{"Ethnicity":"White","Outcome":"A no further action disposal","numPeople":75105},{"Ethnicity":"White","Outcome":"Arrest","numPeople":12566},{"Ethnicity":"White","Outcome":"Community resolution","numPeople":8841},{"Ethnicity":"White","Outcome":"Penalty Notice for Disorder","numPeople":2274},{"Ethnicity":"White","Outcome":"Summons / charged by post","numPeople":1180},{"Ethnicity":"White","Outcome":"Caution (simple or conditional)","numPeople":88}],"transform":[{"type":"formula","expr":"datum['Ethnicity']","as":"stk1","initonly":false},{"type":"formula","expr":"datum['Outcome']","as":"stk2","initonly":false},{"type":"formula","expr":"datum['numPeople']","as":"size","initonly":false}]},{"name":"nodes","source":"outcome","transform":[{"type":"filter","expr":"!groupSelector || groupSelector.stk1 == datum.stk1 || groupSelector.stk2 == datum.stk2"},{"type":"formula","expr":"datum.stk1+datum.stk2","as":"key","initonly":false},{"type":"fold","fields":["stk1","stk2"],"as":["stack","grpId"]},{"type":"formula","expr":"datum.stack == 'stk1' ? datum.stk1+' '+datum.stk2 : datum.stk2+' '+datum.stk1","as":"sortField","initonly":false},{"type":"stack","field":"size","sort":{"field":["sortField"],"order":["descending"]},"groupby":["stack"]},{"type":"formula","expr":"(datum.y0+datum.y1)/2","as":"yc","initonly":false}]},{"name":"groups","source":"nodes","transform":[{"type":"aggregate","fields":["size"],"ops":["sum"],"groupby":["stack","grpId"],"as":["total"]},{"type":"stack","field":"total","sort":{"field":["grpId"],"order":["descending"]},"groupby":["stack"]},{"type":"formula","expr":"scale('yScale', datum.y0)","as":"scaledY0","initonly":false},{"type":"formula","expr":"scale('yScale', datum.y1)","as":"scaledY1","initonly":false},{"type":"formula","expr":"datum.stack == 'stk1'","as":"rightLabel","initonly":false},{"type":"formula","expr":"datum.total/domain('yScale')[1]","as":"percentage","initonly":false}]},{"name":"destinationNodes","source":"nodes","transform":[{"type":"filter","expr":"datum.stack == 'stk2'"}]},{"name":"edges","source":"nodes","transform":[{"type":"filter","expr":"datum.stack == 'stk1'"},{"type":"lookup","from":"destinationNodes","key":"key","fields":["key"],"as":["target"]},{"type":"linkpath","orient":"horizontal","shape":"diagonal","sourceX":{"expr":"scale('xScale', 'stk1') + bandwidth('xScale')"},"sourceY":{"expr":"scale('yScale', datum.yc)"},"targetX":{"expr":"scale('xScale', 'stk2')"},"targetY":{"expr":"scale('yScale', datum.target.yc)"}},{"type":"formula","expr":"range('yScale')[0]-scale('yScale', datum.size)","as":"strokeWidth","initonly":false},{"type":"formula","expr":"datum.size/domain('yScale')[1]","as":"percentage","initonly":false}]}],"signals":[{"name":"groupHover","value":"{}","on":[{"events":"@groupMark:mouseover","update":"{stk1:datum.stack=='stk1' && datum.grpId, stk2:datum.stack=='stk2' && datum.grpId}"},{"events":"mouseout","update":"{}"}]},{"name":"groupSelector","value":false,"on":[{"events":"@groupMark:click!","update":"{stack:datum.stack, stk1:datum.stack=='stk1' && datum.grpId, stk2:datum.stack=='stk2' && datum.grpId}"},{"events":[{"type":"click","markname":"groupReset"},{"type":"dblclick"}],"update":"false"}]}],"scales":[{"name":"xScale","type":"band","domain":["stk1","stk2"],"range":"width","paddingInner":0.95,"paddingOuter":0.05},{"name":"yScale","type":"linear","domain":{"data":"nodes","field":"y1"},"range":"height"},{"name":"cScale","type":"ordinal","range":"category"},{"name":"stackNames","type":"ordinal","domain":["stk1","stk2"],"range":["Ethnicity","Outcome"]}],"axes":[{"scale":"xScale","orient":"top","domain":false,"ticks":false,"labelPadding":10,"encode":{"labels":{"update":{"text":{"scale":"stackNames","field":"value"}}}}},{"scale":"yScale","orient":"left","domain":false,"ticks":false,"labels":false}],"marks":[{"type":"rect","from":{"data":"nodes"},"encode":{"enter":{"width":{"scale":"xScale","band":1},"x":{"scale":"xScale","field":"stack"},"y":{"scale":"yScale","field":"y0"},"y2":{"scale":"yScale","field":"y1"},"fill":{"scale":"cScale","field":"grpId"},"stroke":{"value":"black"},"strokeWidth":{"value":0.2}}}},{"type":"rect","name":"groupMark","from":{"data":"groups"},"encode":{"enter":{"fillOpacity":{"value":0},"fill":{"value":"white"},"width":{"scale":"xScale","band":1},"stroke":{"value":"white"},"strokeWidth":{"value":2},"cornerRadius":{"value":2}},"update":{"x":{"scale":"xScale","field":"stack"},"y":{"field":"scaledY0"},"y2":{"field":"scaledY1"},"tooltip":{"signal":"datum.grpId + ' ' + format(datum.total, ',.0f') + ' (' + format(datum.percentage, '.1%') + ')'"}},"hover":{"strokeOpacity":{"value":1}}}},{"type":"path","name":"edgeMark","from":{"data":"edges"},"clip":true,"encode":{"update":{"stroke":[{"test":"groupSelector && groupSelector.stack=='stk1'","scale":"cScale","field":"stk2"},{"scale":"cScale","field":"grpId"}],"strokeWidth":{"field":"strokeWidth"},"path":{"field":"path"},"strokeOpacity":{"signal":"!groupSelector && (groupHover.stk1 == datum.stk1 || groupHover.stk2 == datum.stk2) ? 0.9 : 0.3"},"zindex":{"signal":"!groupSelector && (groupHover.stk1 == datum.stk1 || groupHover.stk2 == datum.stk2) ? 1 : 0"},"tooltip":{"signal":"datum.stk1 + ' → ' + datum.stk2 + ' ' + format(datum.size, ',.0f') + ' (' + format(datum.percentage, '.1%') + ')'"}},"hover":{"strokeOpacity":{"value":1}}}},{"type":"text","from":{"data":"groups"},"interactive":false,"encode":{"update":{"x":{"signal":"scale('xScale', datum.stack) + (datum.rightLabel ? bandwidth('xScale') + 8 : -8)"},"y":{"signal":"(datum.scaledY0 + datum.scaledY1)/2"},"align":{"signal":"datum.rightLabel ? 'left' : 'right'"},"baseline":{"value":"middle"},"fontWeight":{"value":"bold"},"text":{"signal":"abs(datum.scaledY0-datum.scaledY1) > 13 ? datum.grpId : ''"}}}}]}

{"$schema":"https://vega.github.io/schema/vega/v5.json","width":600,"height":600,"data":[{"name":"reason","values":[{"Ethnicity":"Asian","Reason for search":"Controlled drugs","numPeople":34087},{"Ethnicity":"Asian","Reason for search":"Offensive Weapons","numPeople":5437},{"Ethnicity":"Asian","Reason for search":"Stolen goods","numPeople":2715},{"Ethnicity":"Asian","Reason for search":"Evidence of offences under the Act","numPeople":1217},{"Ethnicity":"Asian","Reason for search":"Anything to threaten or harm anyone","numPeople":885},{"Ethnicity":"Asian","Reason for search":"Firearms","numPeople":196},{"Ethnicity":"Asian","Reason for search":"Fireworks","numPeople":116},{"Ethnicity":"Asian","Reason for search":"Articles for use in criminal damage","numPeople":83},{"Ethnicity":"Black","Reason for search":"Controlled drugs","numPeople":56631},{"Ethnicity":"Black","Reason for search":"Offensive Weapons","numPeople":19617},{"Ethnicity":"Black","Reason for search":"Stolen goods","numPeople":8037},{"Ethnicity":"Black","Reason for search":"Evidence of offences under the Act","numPeople":2800},{"Ethnicity":"Black","Reason for search":"Anything to threaten or harm anyone","numPeople":2001},{"Ethnicity":"Black","Reason for search":"Firearms","numPeople":512},{"Ethnicity":"Black","Reason for search":"Fireworks","numPeople":438},{"Ethnicity":"Black","Reason for search":"Articles for use in criminal damage","numPeople":191},{"Ethnicity":"Other","Reason for search":"Controlled drugs","numPeople":7706},{"Ethnicity":"Other","Reason for search":"Offensive Weapons","numPeople":1872},{"Ethnicity":"Other","Reason for search":"Stolen goods","numPeople":1269},{"Ethnicity":"Other","Reason for search":"Evidence of offences under the Act","numPeople":433},{"Ethnicity":"Other","Reason for search":"Anything to threaten or harm anyone","numPeople":281},{"Ethnicity":"Other","Reason for search":"Firearms","numPeople":85},{"Ethnicity":"Other","Reason for search":"Fireworks","numPeople":49},{"Ethnicity":"Other","Reason for search":"Articles for use in criminal damage","numPeople":25},{"Ethnicity":"White","Reason for search":"Controlled drugs","numPeople":63687},{"Ethnicity":"White","Reason for search":"Offensive Weapons","numPeople":14941},{"Ethnicity":"White","Reason for search":"Stolen goods","numPeople":11433},{"Ethnicity":"White","Reason for search":"Evidence of offences under the Act","numPeople":7163},{"Ethnicity":"White","Reason for search":"Anything to threaten or harm anyone","numPeople":1469},{"Ethnicity":"White","Reason for search":"Firearms","numPeople":665},{"Ethnicity":"White","Reason for search":"Fireworks","numPeople":370},{"Ethnicity":"White","Reason for search":"Articles for use in criminal damage","numPeople":326}],"transform":[{"type":"formula","expr":"datum['Ethnicity']","as":"stk1","initonly":false},{"type":"formula","expr":"datum['Reason for search']","as":"stk2","initonly":false},{"type":"formula","expr":"datum['numPeople']","as":"size","initonly":false}]},{"name":"nodes","source":"reason","transform":[{"type":"filter","expr":"!groupSelector || groupSelector.stk1 == datum.stk1 || groupSelector.stk2 == datum.stk2"},{"type":"formula","expr":"datum.stk1+datum.stk2","as":"key","initonly":false},{"type":"fold","fields":["stk1","stk2"],"as":["stack","grpId"]},{"type":"formula","expr":"datum.stack == 'stk1' ? datum.stk1+' '+datum.stk2 : datum.stk2+' '+datum.stk1","as":"sortField","initonly":false},{"type":"stack","field":"size","sort":{"field":["sortField"],"order":["descending"]},"groupby":["stack"]},{"type":"formula","expr":"(datum.y0+datum.y1)/2","as":"yc","initonly":false}]},{"name":"groups","source":"nodes","transform":[{"type":"aggregate","fields":["size"],"ops":["sum"],"groupby":["stack","grpId"],"as":["total"]},{"type":"stack","field":"total","sort":{"field":["grpId"],"order":["descending"]},"groupby":["stack"]},{"type":"formula","expr":"scale('yScale', datum.y0)","as":"scaledY0","initonly":false},{"type":"formula","expr":"scale('yScale', datum.y1)","as":"scaledY1","initonly":false},{"type":"formula","expr":"datum.stack == 'stk1'","as":"rightLabel","initonly":false},{"type":"formula","expr":"datum.total/domain('yScale')[1]","as":"percentage","initonly":false}]},{"name":"destinationNodes","source":"nodes","transform":[{"type":"filter","expr":"datum.stack == 'stk2'"}]},{"name":"edges","source":"nodes","transform":[{"type":"filter","expr":"datum.stack == 'stk1'"},{"type":"lookup","from":"destinationNodes","key":"key","fields":["key"],"as":["target"]},{"type":"linkpath","orient":"horizontal","shape":"diagonal","sourceX":{"expr":"scale('xScale', 'stk1') + bandwidth('xScale')"},"sourceY":{"expr":"scale('yScale', datum.yc)"},"targetX":{"expr":"scale('xScale', 'stk2')"},"targetY":{"expr":"scale('yScale', datum.target.yc)"}},{"type":"formula","expr":"range('yScale')[0]-scale('yScale', datum.size)","as":"strokeWidth","initonly":false},{"type":"formula","expr":"datum.size/domain('yScale')[1]","as":"percentage","initonly":false}]}],"signals":[{"name":"groupHover","value":"{}","on":[{"events":"@groupMark:mouseover","update":"{stk1:datum.stack=='stk1' && datum.grpId, stk2:datum.stack=='stk2' && datum.grpId}"},{"events":"mouseout","update":"{}"}]},{"name":"groupSelector","value":false,"on":[{"events":"@groupMark:click!","update":"{stack:datum.stack, stk1:datum.stack=='stk1' && datum.grpId, stk2:datum.stack=='stk2' && datum.grpId}"},{"events":[{"type":"click","markname":"groupReset"},{"type":"dblclick"}],"update":"false"}]}],"scales":[{"name":"xScale","type":"band","domain":["stk1","stk2"],"range":"width","paddingInner":0.95,"paddingOuter":0.05},{"name":"yScale","type":"linear","domain":{"data":"nodes","field":"y1"},"range":"height"},{"name":"cScale","type":"ordinal","range":"category"},{"name":"stackNames","type":"ordinal","domain":["stk1","stk2"],"range":["Ethnicity","Reason for search"]}],"axes":[{"scale":"xScale","orient":"top","domain":false,"ticks":false,"labelPadding":10,"encode":{"labels":{"update":{"text":{"scale":"stackNames","field":"value"}}}}},{"scale":"yScale","orient":"left","domain":false,"ticks":false,"labels":false}],"marks":[{"type":"rect","from":{"data":"nodes"},"encode":{"enter":{"width":{"scale":"xScale","band":1},"x":{"scale":"xScale","field":"stack"},"y":{"scale":"yScale","field":"y0"},"y2":{"scale":"yScale","field":"y1"},"fill":{"scale":"cScale","field":"grpId"},"stroke":{"value":"black"},"strokeWidth":{"value":0.2}}}},{"type":"rect","name":"groupMark","from":{"data":"groups"},"encode":{"enter":{"fillOpacity":{"value":0},"fill":{"value":"white"},"width":{"scale":"xScale","band":1},"stroke":{"value":"white"},"strokeWidth":{"value":2},"cornerRadius":{"value":2}},"update":{"x":{"scale":"xScale","field":"stack"},"y":{"field":"scaledY0"},"y2":{"field":"scaledY1"},"tooltip":{"signal":"datum.grpId + ' ' + format(datum.total, ',.0f') + ' (' + format(datum.percentage, '.1%') + ')'"}},"hover":{"strokeOpacity":{"value":1}}}},{"type":"path","name":"edgeMark","from":{"data":"edges"},"clip":true,"encode":{"update":{"stroke":[{"test":"groupSelector && groupSelector.stack=='stk1'","scale":"cScale","field":"stk2"},{"scale":"cScale","field":"grpId"}],"strokeWidth":{"field":"strokeWidth"},"path":{"field":"path"},"strokeOpacity":{"signal":"!groupSelector && (groupHover.stk1 == datum.stk1 || groupHover.stk2 == datum.stk2) ? 0.9 : 0.3"},"zindex":{"signal":"!groupSelector && (groupHover.stk1 == datum.stk1 || groupHover.stk2 == datum.stk2) ? 1 : 0"},"tooltip":{"signal":"datum.stk1 + ' → ' + datum.stk2 + ' ' + format(datum.size, ',.0f') + ' (' + format(datum.percentage, '.1%') + ')'"}},"hover":{"strokeOpacity":{"value":1}}}},{"type":"text","from":{"data":"groups"},"interactive":false,"encode":{"update":{"x":{"signal":"scale('xScale', datum.stack) + (datum.rightLabel ? bandwidth('xScale') + 8 : -8)"},"y":{"signal":"(datum.scaledY0 + datum.scaledY1)/2"},"align":{"signal":"datum.rightLabel ? 'left' : 'right'"},"baseline":{"value":"middle"},"fontWeight":{"value":"bold"},"text":{"signal":"abs(datum.scaledY0-datum.scaledY1) > 13 ? datum.grpId : ''"}}}}]}

{"$schema":"https://vega.github.io/schema/vega/v5.json","width":600,"height":600,"data":[{"name":"comparison","values":[{"Crime":"Controlled drugs","Outcome":"A no further action disposal","numPeople":118709},{"Crime":"Controlled drugs","Outcome":"Community resolution","numPeople":18302},{"Crime":"Controlled drugs","Outcome":"Arrest","numPeople":16548},{"Crime":"Controlled drugs","Outcome":"Penalty Notice for Disorder","numPeople":5730},{"Crime":"Controlled drugs","Outcome":"Summons / charged by post","numPeople":2657},{"Crime":"Controlled drugs","Outcome":"Caution (simple or conditional)","numPeople":165},{"Crime":"Offensive weapons","Outcome":"A no further action disposal","numPeople":31129},{"Crime":"Offensive weapons","Outcome":"Arrest","numPeople":5670},{"Crime":"Offensive weapons","Outcome":"Community resolution","numPeople":808},{"Crime":"Offensive weapons","Outcome":"Penalty Notice for Disorder","numPeople":493},{"Crime":"Offensive weapons","Outcome":"Summons / charged by post","numPeople":254},{"Crime":"Offensive weapons","Outcome":"Caution (simple or conditional)","numPeople":5},{"Crime":"Stolen goods","Outcome":"A no further action disposal","numPeople":20053},{"Crime":"Stolen goods","Outcome":"Arrest","numPeople":5132},{"Crime":"Stolen goods","Outcome":"Community resolution","numPeople":998},{"Crime":"Stolen goods","Outcome":"Penalty Notice for Disorder","numPeople":455},{"Crime":"Stolen goods","Outcome":"Summons / charged by post","numPeople":312},{"Crime":"Stolen goods","Outcome":"Caution (simple or conditional)","numPeople":12},{"Crime":"Evidence of offences under the Act","Outcome":"A no further action disposal","numPeople":9172},{"Crime":"Evidence of offences under the Act","Outcome":"Arrest","numPeople":1970},{"Crime":"Evidence of offences under the Act","Outcome":"Community resolution","numPeople":280},{"Crime":"Evidence of offences under the Act","Outcome":"Penalty Notice for Disorder","numPeople":122},{"Crime":"Evidence of offences under the Act","Outcome":"Summons / charged by post","numPeople":67},{"Crime":"Evidence of offences under the Act","Outcome":"Caution (simple or conditional)","numPeople":2},{"Crime":"Anything to threaten or harm anyone","Outcome":"A no further action disposal","numPeople":4107},{"Crime":"Anything to threaten or harm anyone","Outcome":"Arrest","numPeople":253},{"Crime":"Anything to threaten or harm anyone","Outcome":"Community resolution","numPeople":176},{"Crime":"Anything to threaten or harm anyone","Outcome":"Penalty Notice for Disorder","numPeople":65},{"Crime":"Anything to threaten or harm anyone","Outcome":"Summons / charged by post","numPeople":34},{"Crime":"Anything to threaten or harm anyone","Outcome":"Caution (simple or conditional)","numPeople":1},{"Crime":"Articles for use in criminal damage","Outcome":"A no further action disposal","numPeople":707},{"Crime":"Articles for use in criminal damage","Outcome":"Arrest","numPeople":192},{"Crime":"Articles for use in criminal damage","Outcome":"Community resolution","numPeople":43},{"Crime":"Articles for use in criminal damage","Outcome":"Penalty Notice for Disorder","numPeople":11},{"Crime":"Articles for use in criminal damage","Outcome":"Summons / charged by post","numPeople":11},{"Crime":"Articles for use in criminal damage","Outcome":"Caution (simple or conditional)","numPeople":0},{"Crime":"Firearms","Outcome":"A no further action disposal","numPeople":841},{"Crime":"Firearms","Outcome":"Arrest","numPeople":231},{"Crime":"Firearms","Outcome":"Community resolution","numPeople":26},{"Crime":"Firearms","Outcome":"Penalty Notice for Disorder","numPeople":26},{"Crime":"Firearms","Outcome":"Summons / charged by post","numPeople":3},{"Crime":"Firearms","Outcome":"Caution (simple or conditional)","numPeople":0},{"Crime":"Fireworks","Outcome":"A no further action disposal","numPeople":859},{"Crime":"Fireworks","Outcome":"Arrest","numPeople":38},{"Crime":"Fireworks","Outcome":"Community resolution","numPeople":43},{"Crime":"Fireworks","Outcome":"Penalty Notice for Disorder","numPeople":18},{"Crime":"Fireworks","Outcome":"Summons / charged by post","numPeople":7}],"transform":[{"type":"formula","expr":"datum['Crime']","as":"stk1","initonly":false},{"type":"formula","expr":"datum['Outcome']","as":"stk2","initonly":false},{"type":"formula","expr":"datum['numPeople']","as":"size","initonly":false}]},{"name":"nodes","source":"comparison","transform":[{"type":"filter","expr":"!groupSelector || groupSelector.stk1 == datum.stk1 || groupSelector.stk2 == datum.stk2"},{"type":"formula","expr":"datum.stk1+datum.stk2","as":"key","initonly":false},{"type":"fold","fields":["stk1","stk2"],"as":["stack","grpId"]},{"type":"formula","expr":"datum.stack == 'stk1' ? datum.stk1+' '+datum.stk2 : datum.stk2+' '+datum.stk1","as":"sortField","initonly":false},{"type":"stack","field":"size","sort":{"field":["sortField"],"order":["descending"]},"groupby":["stack"]},{"type":"formula","expr":"(datum.y0+datum.y1)/2","as":"yc","initonly":false}]},{"name":"groups","source":"nodes","transform":[{"type":"aggregate","fields":["size"],"ops":["sum"],"groupby":["stack","grpId"],"as":["total"]},{"type":"stack","field":"total","sort":{"field":["grpId"],"order":["descending"]},"groupby":["stack"]},{"type":"formula","expr":"scale('yScale', datum.y0)","as":"scaledY0","initonly":false},{"type":"formula","expr":"scale('yScale', datum.y1)","as":"scaledY1","initonly":false},{"type":"formula","expr":"datum.stack == 'stk1'","as":"rightLabel","initonly":false},{"type":"formula","expr":"datum.total/domain('yScale')[1]","as":"percentage","initonly":false}]},{"name":"destinationNodes","source":"nodes","transform":[{"type":"filter","expr":"datum.stack == 'stk2'"}]},{"name":"edges","source":"nodes","transform":[{"type":"filter","expr":"datum.stack == 'stk1'"},{"type":"lookup","from":"destinationNodes","key":"key","fields":["key"],"as":["target"]},{"type":"linkpath","orient":"horizontal","shape":"diagonal","sourceX":{"expr":"scale('xScale', 'stk1') + bandwidth('xScale')"},"sourceY":{"expr":"scale('yScale', datum.yc)"},"targetX":{"expr":"scale('xScale', 'stk2')"},"targetY":{"expr":"scale('yScale', datum.target.yc)"}},{"type":"formula","expr":"range('yScale')[0]-scale('yScale', datum.size)","as":"strokeWidth","initonly":false},{"type":"formula","expr":"datum.size/domain('yScale')[1]","as":"percentage","initonly":false}]}],"signals":[{"name":"groupHover","value":"{}","on":[{"events":"@groupMark:mouseover","update":"{stk1:datum.stack=='stk1' && datum.grpId, stk2:datum.stack=='stk2' && datum.grpId}"},{"events":"mouseout","update":"{}"}]},{"name":"groupSelector","value":false,"on":[{"events":"@groupMark:click!","update":"{stack:datum.stack, stk1:datum.stack=='stk1' && datum.grpId, stk2:datum.stack=='stk2' && datum.grpId}"},{"events":[{"type":"click","markname":"groupReset"},{"type":"dblclick"}],"update":"false"}]}],"scales":[{"name":"xScale","type":"band","domain":["stk1","stk2"],"range":"width","paddingInner":0.95,"paddingOuter":0.05},{"name":"yScale","type":"linear","domain":{"data":"nodes","field":"y1"},"range":"height"},{"name":"cScale","type":"ordinal","range":"category"},{"name":"stackNames","type":"ordinal","domain":["stk1","stk2"],"range":["Crime","Outcome"]}],"axes":[{"scale":"xScale","orient":"top","domain":false,"ticks":false,"labelPadding":10,"encode":{"labels":{"update":{"text":{"scale":"stackNames","field":"value"}}}}},{"scale":"yScale","orient":"left","domain":false,"ticks":false,"labels":false}],"marks":[{"type":"rect","from":{"data":"nodes"},"encode":{"enter":{"width":{"scale":"xScale","band":1},"x":{"scale":"xScale","field":"stack"},"y":{"scale":"yScale","field":"y0"},"y2":{"scale":"yScale","field":"y1"},"fill":{"scale":"cScale","field":"grpId"},"stroke":{"value":"black"},"strokeWidth":{"value":0.2}}}},{"type":"rect","name":"groupMark","from":{"data":"groups"},"encode":{"enter":{"fillOpacity":{"value":0},"fill":{"value":"white"},"width":{"scale":"xScale","band":1},"stroke":{"value":"white"},"strokeWidth":{"value":2},"cornerRadius":{"value":2}},"update":{"x":{"scale":"xScale","field":"stack"},"y":{"field":"scaledY0"},"y2":{"field":"scaledY1"},"tooltip":{"signal":"datum.grpId + ' ' + format(datum.total, ',.0f') + ' (' + format(datum.percentage, '.1%') + ')'"}},"hover":{"strokeOpacity":{"value":1}}}},{"type":"path","name":"edgeMark","from":{"data":"edges"},"clip":true,"encode":{"update":{"stroke":[{"test":"groupSelector && groupSelector.stack=='stk1'","scale":"cScale","field":"stk2"},{"scale":"cScale","field":"grpId"}],"strokeWidth":{"field":"strokeWidth"},"path":{"field":"path"},"strokeOpacity":{"signal":"!groupSelector && (groupHover.stk1 == datum.stk1 || groupHover.stk2 == datum.stk2) ? 0.9 : 0.3"},"zindex":{"signal":"!groupSelector && (groupHover.stk1 == datum.stk1 || groupHover.stk2 == datum.stk2) ? 1 : 0"},"tooltip":{"signal":"datum.stk1 + ' → ' + datum.stk2 + ' ' + format(datum.size, ',.0f') + ' (' + format(datum.percentage, '.1%') + ')'"}},"hover":{"strokeOpacity":{"value":1}}}},{"type":"text","from":{"data":"groups"},"interactive":false,"encode":{"update":{"x":{"signal":"scale('xScale', datum.stack) + (datum.rightLabel ? bandwidth('xScale') + 8 : -8)"},"y":{"signal":"(datum.scaledY0 + datum.scaledY1)/2"},"align":{"signal":"datum.rightLabel ? 'left' : 'right'"},"baseline":{"value":"middle"},"fontWeight":{"value":"bold"},"text":{"signal":"abs(datum.scaledY0-datum.scaledY1) > 13 ? datum.grpId : ''"}}}}]}

4. Which boroughs in London saw the most crimes committed? Was this different from when London was in lockdown compared to out of Lockdown?

{"$schema":"https://vega.github.io/schema/vega-lite/v5.json","width":600,"height":400,"config":{"view":{"stroke":null},"legend":{"orient":"bottom-right","offset":0}},"data":{"url":"https://gicentre.github.io/data/geoTutorials/londonBoroughs.json","format":{"type":"topojson","feature":"boroughs"}},"transform":[{"lookup":"id","from":{"data":{"values":[{"borough":"Barking and Dagenham","crimeNum":26350},{"borough":"Barnet","crimeNum":41077},{"borough":"Bexley","crimeNum":22961},{"borough":"Brent","crimeNum":43687},{"borough":"Bromley","crimeNum":32077},{"borough":"Camden","crimeNum":42780},{"borough":"City of London","crimeNum":622},{"borough":"Croydon","crimeNum":46915},{"borough":"Ealing","crimeNum":44646},{"borough":"Enfield","crimeNum":42590},{"borough":"Greenwich","crimeNum":35917},{"borough":"Hackney","crimeNum":47037},{"borough":"Hammersmith and Fulham","crimeNum":27947},{"borough":"Haringey","crimeNum":43529},{"borough":"Harrow","crimeNum":23863},{"borough":"Havering","crimeNum":24722},{"borough":"Hillingdon","crimeNum":39106},{"borough":"Hounslow","crimeNum":35779},{"borough":"Islington","crimeNum":38559},{"borough":"Kensington and Chelsea","crimeNum":26305},{"borough":"Kingston upon Thames","crimeNum":16832},{"borough":"Lambeth","crimeNum":47913},{"borough":"Lewisham","crimeNum":39683},{"borough":"Merton","crimeNum":20097},{"borough":"Newham","crimeNum":48620},{"borough":"Redbridge","crimeNum":33196},{"borough":"Richmond upon Thames","crimeNum":19132},{"borough":"Southwark","crimeNum":47697},{"borough":"Sutton","crimeNum":19113},{"borough":"Tower Hamlets","crimeNum":55021},{"borough":"Waltham Forest","crimeNum":36330},{"borough":"Wandsworth","crimeNum":37494},{"borough":"Westminster","crimeNum":65660}]},"key":"borough","fields":["crimeNum"]}}],"encoding":{"color":{"field":"crimeNum","type":"quantitative","title":"Total Crime 2020"},"tooltip":[{"field":"id"},{"field":"crimeNum"}]},"mark":{"type":"geoshape","stroke":"white"}}

{"$schema":"https://vega.github.io/schema/vega-lite/v5.json","width":600,"height":400,"config":{"view":{"stroke":null},"legend":{"orient":"bottom-right","offset":0}},"data":{"url":"https://gicentre.github.io/data/geoTutorials/londonBoroughs.json","format":{"type":"topojson","feature":"boroughs"}},"transform":[{"lookup":"id","from":{"data":{"values":[{"borough":"Barking and Dagenham","crimeNum":12460},{"borough":"Barnet","crimeNum":19629},{"borough":"Bexley","crimeNum":11089},{"borough":"Brent","crimeNum":20509},{"borough":"Bromley","crimeNum":15041},{"borough":"Camden","crimeNum":26431},{"borough":"City of London","crimeNum":419},{"borough":"Croydon","crimeNum":18675},{"borough":"Ealing","crimeNum":21367},{"borough":"Enfield","crimeNum":19911},{"borough":"Greenwich","crimeNum":17121},{"borough":"Hackney","crimeNum":22373},{"borough":"Hammersmith and Fulham","crimeNum":13631},{"borough":"Haringey","crimeNum":20367},{"borough":"Harrow","crimeNum":14356},{"borough":"Havering","crimeNum":11850},{"borough":"Hillingdon","crimeNum":18821},{"borough":"Hounslow","crimeNum":17023},{"borough":"Islington","crimeNum":19196},{"borough":"Kensington and Chelsea","crimeNum":13198},{"borough":"Kingston upon Thames","crimeNum":8142},{"borough":"Lambeth","crimeNum":23140},{"borough":"Lewisham","crimeNum":18732},{"borough":"Merton","crimeNum":9631},{"borough":"Newham","crimeNum":22949},{"borough":"Redbridge","crimeNum":15851},{"borough":"Richmond upon Thames","crimeNum":9019},{"borough":"Southwark","crimeNum":23247},{"borough":"Sutton","crimeNum":8944},{"borough":"Tower Hamlets","crimeNum":25608},{"borough":"Waltham Forest","crimeNum":17046},{"borough":"Wandsworth","crimeNum":17536},{"borough":"Westminster","crimeNum":37828}]},"key":"borough","fields":["crimeNum"]}}],"encoding":{"color":{"field":"crimeNum","type":"quantitative","title":"Total Crime Ouside Lockdown"},"tooltip":[{"field":"id"},{"field":"crimeNum"}]},"mark":{"type":"geoshape","stroke":"white"}}

{"$schema":"https://vega.github.io/schema/vega-lite/v5.json","width":600,"height":400,"config":{"view":{"stroke":null},"legend":{"orient":"bottom-right","offset":0}},"data":{"url":"https://gicentre.github.io/data/geoTutorials/londonBoroughs.json","format":{"type":"topojson","feature":"boroughs"}},"transform":[{"lookup":"id","from":{"data":{"values":[{"borough":"Barking and Dagenham","crimeNum":13890},{"borough":"Barnet","crimeNum":21448},{"borough":"Bexley","crimeNum":11872},{"borough":"Brent","crimeNum":23178},{"borough":"Bromley","crimeNum":17036},{"borough":"Camden","crimeNum":16349},{"borough":"City of London","crimeNum":203},{"borough":"Croydon","crimeNum":28240},{"borough":"Ealing","crimeNum":23279},{"borough":"Enfield","crimeNum":22679},{"borough":"Greenwich","crimeNum":18796},{"borough":"Hackney","crimeNum":24664},{"borough":"Hammersmith and Fulham","crimeNum":14316},{"borough":"Haringey","crimeNum":23162},{"borough":"Harrow","crimeNum":9507},{"borough":"Havering","crimeNum":12872},{"borough":"Hillingdon","crimeNum":20285},{"borough":"Hounslow","crimeNum":18756},{"borough":"Islington","crimeNum":19363},{"borough":"Kensington and Chelsea","crimeNum":13107},{"borough":"Kingston upon Thames","crimeNum":8690},{"borough":"Lambeth","crimeNum":24773},{"borough":"Lewisham","crimeNum":20951},{"borough":"Merton","crimeNum":10466},{"borough":"Newham","crimeNum":25671},{"borough":"Redbridge","crimeNum":17345},{"borough":"Richmond upon Thames","crimeNum":10113},{"borough":"Southwark","crimeNum":24450},{"borough":"Sutton","crimeNum":10169},{"borough":"Tower Hamlets","crimeNum":29413},{"borough":"Waltham Forest","crimeNum":19284},{"borough":"Wandsworth","crimeNum":19958},{"borough":"Westminster","crimeNum":27832}]},"key":"borough","fields":["crimeNum"]}}],"encoding":{"color":{"field":"crimeNum","type":"quantitative","title":"Total Crime During Lockdown 2020"},"tooltip":[{"field":"id"},{"field":"crimeNum"}]},"mark":{"type":"geoshape","stroke":"white"}}

{|visualization)}

{(insights|}

For this project, we wanted to investigate trends of crime in London and how the metropolitan police carried out their duties in 2020. We segmented this down into 4 questions scrutinizing temporal and geospatial trends as well as the breakdown of the demographic of those stop and searched by the police. The following insights were found:

For our first research question, we present our visualization titled “highlighted”. We find that outside of Lockdown between January-March and July-September similarity in the number of stop and searches by the police around 16,000-19,000. We find a significant increase to stop and searches during the first lockdown almost up by 100%, the second lockdown followed the same trends however a much smaller increase at 25% in stop and searches during the second lockdown. Considering, the lockdown itself was one of the most unprecedented restrictions posed by the government to date, it takes time and effort i.e., policing to enforce this. This visualization shows that there was a potential over enforcement by the police but also shows that the police were far more prepared during the second lockdown. Furthermore, the difference in the increase of stops and searches shows that the government had effectively informed citizens.

We created four visualizations for our second question to be able to gain a spectrum of insights. From our first visualization, we can derive immediately that Black individuals aged between 18-24 were the most stopped throughout the year. Interestingly this age group is the highest stopped across all ethnic groups. Our second visualization further develops our insight, expressing stop and searches via outcomes. Here scrutinizing all outcomes, we find the same trends across all outcomes, although we find that majority of stop and searches were given an outcome of no further action, where white ethnics were given the most, closely followed by black ethnics. Our third visualizations translate this into a temporal visualization. White and Black ethnic stop and search recorded seems almost identical trends throughout the year, with slight peaks during the lockdown as expected seen in Q1. We find however higher peaks with black ethnic groups; however, these are not consistent. Our 4th visualization shows the same data as the first however here we can see the proportions of each ethnic group via age group. We also find that Black 18-24 year olds are have been 5,000 more times than the their white counterparts however compared for the 25-34 age range we find white ethnic groups to be stopped the most, 6000 more times than their black conterparts. This is an interesting finding, and could suggest, does age have an impact to ethnic crime rates.

For our third visualization, our 3rd research question slightly intersects our 2nd research question however here we wanted to scrutinize how reasons for being stopped translated in the outcome of stops. Our first visualization deepens our 2nd visualization for our 2nd question however we visualize the proportions compared to ethnic groups. Our second visualizations we can see that majority of stop and searches was due to suspicion of drugs at 65%. We also find a large proportion of the reason for the search was due to an offensive weapon, where half of all stops were of black ethnics. Our third visualization analyses down the crime committed with the outcome. Here we find no further action shares a proportional relationship across all crimes committed. Focusing on arrests we also find the same proportional relationship where more than half of arrests come from controlled drugs, offensive weapons, and stolen goods respectively share almost the same proportions of arrests with 17% and 18%. interestingly 75% of the suspicion of Firearms were given no further action whereas only 20% of Firearms stops were arrested. This could be down to the wrong source of information from potential gangs or potentially an over-policing which could be linked to our previous findings of 18–24-year-old being the majority of stops.

Here we used geospatial analysis to be able to visualize our data segmented by boroughs and the number of crimes committed within those boroughs. Here we find that Westminster and tower hamlets had the most crimes committed throughout 2020. Considering through the end of March to June and October to December we were in lockdown. We filtered out each month and visualized this on the following two visualizations of London. We find the Westminster continuously had high crime rates in and out of lockdown however we find that majority of boroughs saw a surge of crimes committed when London went into Lockdown. We find peripheral boroughs of London level of crime stayed more consistent, boroughs like Kingston, Harrow, Havering, and Bexley crime rate barely changed when the lockdown was enforced by the government. We saw a greater change in inner-city crime rates variance in crime rates for inner boroughs. Croydon was the biggest difference, we saw a 55% increase in crime during Lockdown.

{|insights)}

{(designJustification|}

The recent light shed on the unreasonable treatment of black citizens in America by the police, which was transmitted to recent riots in London, has led me to focus on policing by demographic. Therefore, considering our target audience of these visualizations would be the general public who may need this information to demystify any false narratives. Furthermore, the route by which this visualization would be sourced to the public would be either the News or government/world organization. Our main aim to make sure the information we present is clearly understood and most importantly memorable. We considered recent research [2] which suggests that bar graphs are the most used within these channels. Bar plots are among the least memorable graphs, however, are amongst the easiest to understand. Given the need to explore this data, our target audience, and potential mediums which would be used to publish this visualization we chose to use faceted Bar graphs to explore the demographic of those stopped and searched and their respective outcome aggregated. We used neutral colours to denote respective races while aligning our bar chart horizontally against each other allows easy comparison to be made. We didn’t add interactions in our bar charts, rather utilising a faceted view allows us to control our visualization. We done this in parallel with the Data Feminism approach. “Understanding of emotion can expand our ideas about effective data Visualisation” [3] hence in this case we understand the uproar, confusion, and anger from our audience therefore, providing an interactive visualization was not needed here. Rather clear, concise, and easily absorbed visualization was our chosen route, which would address emotions and deflate narratives.

We utilised the Sankey diagram for a few of our visualizations for this project. Derived from engineering and used to visualize the efficiency of steam engines, the Sankey diagram which visualizes nodal connections and flows between two or more points. Our process of utilising the Sankey diagram consisted of several iterations. Considering Kindlmann and Scheidegger’s Commutative Diagram [4], we initially had one form of data which was a full-scaled CSV, which was partly pre-processed. Here we found our visualization fairly restrictive, we aggregated our data to represent exactly what we needed to visualize and created a JSON file. In our first Sankey diagram for our research question 3, we represented the same information we represented in our ethnic-outcomes bar chart for our research question 2 which showed an identity transformation, which enriched our visualization while allowing our targeted audience to take away percentages as proportional flows. This added an elegant and attractive touch to our visualization which Tufte [5] states allows the visualization to tell a story about the data.

Our data is of London crime throughout 2020 hence, both temporal and geospatial data is presented in the spectacles of policing in London. Taking Tobler’s first law of geography [6] “..near things are more related than distant things” literally. We decided to use a 2D geospatial mapping of the boroughs of London. Iterating 3 mapping projections that encapsulate our research questions. Our choice to use this mapping projection allowed us to discover clusters of where crime had risen during the lockdown, otherwise would not have been able to without this visualisation. We chose not to relax our boundaries and rather keep boundaries untouched, which allows our visualization to keep its rigid features. We used a continuous colour scheme as binning our colour choice would take away the ability to translate how much a borough's crime rate had changed per borough. Therefore, we utilised colour as a variable to distinguish this, making sure we keep our audience in mind when deciding on the colour we use. We looked at the “Colours in Culture” from Information is Beautiful [7]. Which states the shades from blue to yellow/white symbolises Loyalty, Unhappiness, Truce, and Freedom. Which is how we are aiming to appeal to our audience, making sure this visualization comes across empathetic was a strategic choice of colours.

{|designJustification)}

{(validation|}

Our visualizations allowed us to explore using geospatial and temporal which enabled clusters that otherwise would not have been able to be seen nor analysed looking at the raw form of our tabular data. Our geospatial visualization allows our audience to derive how certain parts of the London boroughs simultaneously saw an increase/decrease in crime rates. This could be linked to potential infrastructure between the cluster of boroughs or the demographic of people living within these boroughs may be similar. We were able to segment our temporal view of crime highlighting lockdown while similarly vertically placing our choropleth, and utilising horizontal faceting when comparing ethnic stop and search over 2020. This enables our audience to easily extract and compare results. Links can be made between ethnic groups which allow the audience to derive how peaks within ethnic groups are translated to the whole picture of stop and searches across London. Furthermore, we were able to see how other ethnic groups which may have had a low number of stop and searches offset those who have a peak throughout the year.

One major limitation of our choropleth visualization is our continuous colour scheme, which normalizes across each visualization. If you look at our London Choropleth 1 visualization, we find highly intensified blue colour boroughs denote high crime numbers. However, in our 2nd and 3rd London Choropleth, we find that because we have extracted our data for months of Lockdown, our minimum and maximum values have changed hence the change of colour, does not necessarily translate to an increase or decrease in crime rates in the borough. What we would have done differently here if given the opportunity, is taking the percentage of crime against the population of the boroughs during the lockdown and computing these visually. This way we standardize our crime rates against the population which we keep consistent through all our visualization.

The Sankey diagram, allowed us to express our data in a flow, depicting ethnic groups to reasons and outcomes of crime. Although this allowed a unique application of the visualization, the element of time and geographic location was eliminated. Given the nature of our data and research, this element is vital, understanding how lockdown may have impacted these reasons/outcomes of stop and searches would have added far more value. Although like the choropleth visualization, we could have filtered our data which linked to lockdown out, hence producing a separate visualization. This still doesn’t describe our data in a way in which temporal trends could be extracted. Furthermore, we incorporated two datasets in this research, crime data and stop and search data. However, our crime data wasn’t as descriptive as our stop and search data which limited our scope to visualize effectively.

{|validation)}

{(references|}

[1] Data set downloaded from - https://data.police.uk/data/ - Between Jan2020 - Dec2020 Both Crime data and Stop and search data between January - December

[2] Borkin, M., Vo, A., Bylinskii, Z., Isola, P., Sunkavalli, S., Oliva, A. and Pfister, H. (2013) What makes a visualization memorable? IEEE Transactions on Visualization and Computer Graphics, 19(12), pp.2306-2315.

[3] D'Ignazio, C. and Klein, L. (2020) Data Feminism.MIT Press

[4] Kindlmann, G. and Scheidegger, C. (2014) An algebraic process for visualization design IEEE transactions on Visualization and Computer Graphics 20(12), pp.2181-2190.

[5] Tufte, E. (2001) The Visual Display of Quantitative Information, Cheshire, Connecticut: Graphics Press.

[6] Tobler, W.. “Movie Simulating Urban Growth in the Detroit Region Author ( s ) :.” (2005).

[7] Information is Beautiful - Colohttps://informationisbeautiful.net/visualizations/colours-in-cultures/

{|references)}